﻿CREATE TABLE [app].[OpenIdUser] (
    [Id]       BIGINT         IDENTITY (1, 1) NOT NULL,
    [DNS]      NVARCHAR (128) NOT NULL,
    [Alias]    NVARCHAR (128) NOT NULL,
    [Email]    NVARCHAR (128) NOT NULL,
    [FullName] NVARCHAR (128) NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_OpenIdUser_UniqueUser]
    ON [app].[OpenIdUser]([DNS] ASC, [Alias] ASC);

